CQL Access Points for Community Information
This section lists the CQL (Common Query Language) access points you can use to construct custom search filters for Polaris PowerPAC community information searches. For more information about this procedure, see Specify Community Keyword search filters. The CQL search command can include the following parts:
- The text for which you are searching
- The access points (fields) you want to search; for example, organization name or event name (see
- Operators (connectors) that link one part of the search with another. See Boolean Operators and Relative Operators.
Boolean Operators
The Boolean operators And, Or, and Not combine search terms:
- And - A record must match both the term before and the term after the operator to be included in the search results.
- Or - A record can match either the term before or the term after the operator, or both, to be included in the search results.
Example:
KW=term1 OR KW=term2
If you have a number of terms to combine with OR, type the command this way:
KW={list}term1, term2, term3, term4{/list}
You can insert as many terms as you need between {list} and {/list}
- Not - A record must match the term before the operator, but not the term after the operator, to be included in the search results.
If you use multiple operators in the same search command, use parentheses to group the operations to be performed.
Search Text That Includes Operators or Special Characters
To search for text that includes an operator or special characters as part of the search text, put the entire search text in double quotation marks.
Relative Operators
Relative operators are symbols that compare search terms:
| Symbol | Relative Operation |
|---|---|
|
= |
Equal to search term |
|
<> |
Not equal to a single search term: ED <> date1 |
|
>= |
Greater than or equal to search term |
|
> |
Greater than search term |
|
<= |
Less than or equal to search term |
|
< |
Less than search term |
Search Access Point (Field) Codes - Community Information
| Access Point | Description |
|---|---|
|
ADR |
Address and contact person |
|
CN |
Control number |
|
KW |
All keyword fields |
|
NOTE |
Notes |
|
PC |
Postal code |
|
PN |
Organization name |
|
SA |
Services available |
|
SU |
Subject |
|
TI |
Event name |
|
TOOID |
Type of organization (TOOID=): EVT - Event PER - Individual ORG - Organization or Club OTH - Other PRO - Program or service SPO - Sponsor or donor |